Displaying and editing matrices
Visum provides various options for displaying and editing matrices or using them for calculations.
Functions used to display and analyze matrices |
Highlighting matrix sections in color |
Showing matrix values in an aggregated form |
Filtering matrix values |
Displaying matrix values as a histogram |
Comparing matrices graphically in pairs |
Visum offers both simple and more complex operations for editing and calculating matrices. Most operations can be performed directly in the Matrix editor (User Manual: Managing, showing and analyzing matrices), others are available as functions in formulas (User Manual: Creating a matrix calculated from a formula) or as procedures (User Manual: Setting the procedure sequence).
Functions for copying / replacing matrix values |
Matrix editor |
Formulas |
Edit individual matrix values interactively |
X |
|
Set values conditionally |
X |
X |
Form constant matrix |
X |
X |
Transpose |
X |
X |
Reflect upper or lower triangle |
X |
X |
Set diagonal |
X |
X |
Copy diagonal to clipboard / Paste diagonal from clipboard |
X |
|
Arithmetic operations on matrices |
Matrix editor |
Formulas |
Round (to value to be specified) |
X |
|
Round (to number of decimal places to be specified) |
|
X |
Floor (to integer) |
|
X |
Ceil (to integer) |
|
X |
Truncate (to number of decimal places to be specified) |
|
X |
Add / subtract matrices |
X |
X |
Multiply / divide matrices (element-wise) |
X |
X |
Form reciprocal (element-wise) |
X |
X |
Raise to power (element-wise) |
X |
X |
Take logarithm (element-wise) |
X |
X |
Exponential function (element-wise) |
X |
X |
Forming maximum or minimum |
X |
X |
Symmetrize matrix (calculate average values pairwise from top and bottom triangle) |
X |
X |
MSA (Method of Successive Averages) |
X |
X |
GEH statistics |
X |
X |
Arithmetic operations on matrices |
Matrix editor | Procedure |
Projection: various procedures |
X |
|
Projection by territory |
X |
|
Calculate matrix using marginal totals, i.e. trip distribution (Gravity model calculation) |
|
X |
Generate main zone matrix from a zone matrix (aggregate) and generate zone matrix from a main zone matrix (disaggregate) |
X |
X |
Arithmetic operations with two or more matrices |
Matrix editor |
Formulas |
Sum of multiple matrices (for each element) |
x* |
X |
Product of multiple matrices (for each element) |
x* |
X |
Minimum of multiple matrices (for each element) |
x* |
X |
Maximum of multiple matrices (for each element) |
x* |
X |
Average of multiple matrices (for each element) |
x* |
X |
* via Combination of matrices and vectors symbol
Functions for structural changes to matrices |
Matrix editor |
Procedure |
Extend matrix (include new OD pairs in matrix for arithmetic operations) |
|
X |
Aggregate / disaggregate (summarize rows/columns of a matrix) |
|
X |
Split/Extend (rows/columns of a matrix into/to several ones) |
X |
|
Form partial matrix (non-symmetric aggregation) |
X |
|
You can use formulas to have some matrices calculated automatically and then use them in your model (Using calculated matrices)